package com.baohua.dao;

import java.util.List;

import com.baohua.model.Staff;
import com.baohua.model.Supplier;

public interface SupplierDao {
	/**
	 * 根据SQL语句查询供应商列表
	 * @return
	 */
	public List<Supplier> querySupplier(String sql, int page, int pageSize);
	
	/**
	 * 根据供应商编号查询供应商
	 * @param supplierNo
	 * @return
	 */
	public Supplier querySupplierBySupplierNo(String supplierNo);
	
	
	
	/**
	 * 增加供应商
	 * @param supplier
	 */
	public void addSupplier(Supplier supplier);
	
	/**
	 * 删除供应商
	 * @param supplier
	 */
	public void delSupplier(Supplier supplier);
	
	/**
	 * 修改供应商
	 * @param supplier
	 */
	public void updateSupplier(Supplier supplier);
	
	/**
	 * 统计供应商总数
	 * @param sql
	 * @return
	 */
	public long countSupplier(String sql);
	
	/**
	 * 根据供应商Id进行查询
	 * @param supplierId
	 * @return
	 */
	public Supplier querySupplierBySupplierId(int supplierId);
	
}
